Must be local to the Twin Cities to be considered.
NorthShore Resources has a contract to hire position to help our client move their Oracle Database Administration into a DevOps environment. This role creates infrastructure as code pipelines and automation within our client's predefined database architecture. This position works closely with application developers to identify needs and set up appropriate data pipelines to maintain the effectiveness and efficiency of the database. The administrator assists data-engineers in the creation of functions and automation that pertain to development, analysis, performance tuning, and modeling of data.
Required Qualifications:

• 4-year college degree in Computer Science, Math, Engineering, or related field OR 3 years IS&T related experience
• Self-learner with strong desire to solve hard problems
• 2 years experience with DevOps or database administration
• 2 years experience SQL and PL/SQL or T-SQL programming
• 2 years experience with Unix shell, Perl, or OS scripting language
• 2 years experience with performance tuning
• Strong knowledge of operating systems (i.e., Windows, Linux)
• Excellent oral and written communication skills
• Experience with database backup and recovery
• Available to work outside normal business hours, including weekends and be on-call (7 days x 24 hours)
• Effectively use Microsoft tools, including Outlook, Word, Excel, Visio, and PowerPoint

Preferred Qualifications/Skills:

• Hands on experience with DevOps and Automation (i.e., Ansible, Jenkins, Git).
• Hands on experience with Openshift
• Hands on experience with Liquibase
• Hands on experience provisioning infrastructure using Terraform
• Hands on experience with Azure Public Cloud
• Experience working in an agile/scrum team.
• Administration of Oracle Exadata appliance.
• Oracle Certified Professional - OCP DBA Professional
• Experience with MySQL and Microsoft SQL Databases

Hours/Location:

• M-F; days with on-call (after hours support).
• This position may work remotely but will prefer local/regional candidates for occasional onsite needs

Accountabilities:

• Automates the creation and maintenance of databases for all environments.
• Provides primary DB support for implementing, upgrading, and maintaining the DBMS (Oracle) environments.
• Develops new technologies and techniques to optimize database stability, resilience, and security.
• Monitors and resolve application connectivity and DB interface issues; proactively working with other support teams to ensure that application problems do not adversely affect production operations.
• Collaborates with application developers and vendors to report and resolve problems.
• Implements and tests database backup and recovery technology / procedures for database environments.
• Mentors and educates technical staff, DB users and vendors in techniques to optimize query performance.
• Ensures compliance of all DB security standards in collaboration with IS&T Security Management.
• Debugs problematic database issues, provide analysis for future enhancements and development; proactively maintaining effective and efficient database structures and system processing.
• Forecasts and analyzes future capacity needs and develops tools and utilities to mitigate future capacity issues.